| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
Id |
|
INTEGER |
NO |
|
DisbursementApprovalRuleId |
|
INTEGER |
NO |
|
| Code |
|
CHAR(10) |
NO |
|
| Name |
|
VARCHAR(40) |
NO |
|
| IsMinPctAttendanceRequired |
|
BIT |
NO |
|
| MinPctAttendance |
|
NUMERIC(8, 2) |
NO |
|
| IsMinHoursAttendanceRequired |
|
BIT |
NO |
|
| MinHoursAttended |
|
NUMERIC(9, 2) |
NO |
|
| IsMinNumericAvgRequired |
|
BIT |
NO |
|
| MinNumericAverage |
|
NUMERIC(11, 6) |
NO |
|
| IsMinCumulativeGpaRequired |
|
BIT |
NO |
|
| MinCumulativeGPA |
|
NUMERIC(18, 6) |
NO |
|
| IsMinHoursCreditsScheduledRequired |
|
BIT |
NO |
|
| MinClockHoursScheduled |
|
NUMERIC(18, 2) |
NO |
|
| MinCreditHoursScheduled |
|
NUMERIC(18, 2) |
NO |
|
| IsMinHoursCreditsCompletedRequired |
|
BIT |
NO |
|
| MinClockHoursCompleted |
|
NUMERIC(18, 2) |
NO |
|
| MinCreditHoursCompleted |
|
NUMERIC(18, 2) |
NO |
|
| IsFaCreditsHoursEarnedAttemptedRequired |
|
BIT |
NO |
|
| FaCreditsHoursEarnedAttemptedFlag |
|
CHAR(1) |
NO |
|
| IsMaxDaysAfterStudentLdaRequired |
|
BIT |
NO |
|
| MaxDaysAfterStudentLda |
|
INTEGER |
NO |
|
| IsMissingDocumentsChecked |
|
BIT |
NO |
|
| IsStudentSchoolStatusChecked |
|
BIT |
NO |
|
| IsMeetingSapRequired |
|
BIT |
NO |
|
| RequiredStudentSap |
|
CHAR(8) |
NO |
|
| IsIsirOnFileRequired |
|
BIT |
NO |
|
| IsAcceptedOriginationRequired |
|
BIT |
NO |
|
| IsVerificationStatusChecked |
|
BIT |
NO |
|
| VerificationStatus |
|
VARCHAR(25) |
NO |
|
| IsMaxDisbursementAmountDifferenceChecked |
|
BIT |
NO |
|
| MaxDisbursementAmountDifference |
|
MONEY(19, 4) |
NO |
|
| IsMaxDaysPriorTermStartDateChecked |
|
BIT |
NO |
|
| MaxDaysPriorTermStartDate |
|
INTEGER |
NO |
|
| IsFirstTimeBorrowerRule |
|
BIT |
NO |
|
| IsMaxDaysFromLoanPeriodEndDateChecked |
|
BIT |
NO |
|
| MaxDaysFromLoanPeriodEndDate |
|
INTEGER |
NO |
|
| IsActive |
|
BIT |
NO |
|
LastModifiedUserId |
|
INTEGER |
NO |
|
| CreatedDateTime |
|
DATETIME |
NO |
|
| LastModifiedDateTime |
|
DATETIME |
NO |
|
| RowVersion |
|
TIMESTAMP/DATE |
NO |
|
| IsEnrollmentToPackageStatusRequired |
|
BIT |
NO |
|
| IsEvaluationByTerm |
|
BIT |
NO |
|
| IsAttendanceAllCoursesEvaluated |
|
BIT |
NO |
|
| IsDocumentCompletionDateConfirmed |
|
BIT |
NO |
|
| IsOriginationCertifiedBeforeLda |
|
BIT |
NO |
|
| IsResidencyStateChecked |
|
BIT |
NO |
|
| ResidencyState |
|
CHAR(2) |
YES |
|
| IsStateResidentSinceChecked |
|
BIT |
NO |
|
| ResidencyStateYears |
|
SMALLINT |
YES |
|
| BachelorsDegree |
|
CHAR(1) |
NO |
|
| GraduateLevelProgram |
|
CHAR(1) |
NO |
|
| IsEntranceInterviewRequired |
|
BIT |
NO |
|
MinEnrollmentStatusId |
|
INTEGER |
YES |
|
| IsMinPaymentPeriodHoursAttendedRequired |
|
BIT |
NO |
|
| MinPaymentPeriodHoursAttended |
|
NUMERIC(9, 2) |
NO |
|
| Check Constraint Name |
CheckConstraint |
| Chk_FaApproveDisbCriteriaSubsequent_MinCumulativeGPAFlag_MinCumulativeGPA |
([MinCumulativeGPAFlag]=(1) AND [MinCumulativeGPA]>(0) OR [MinCumulativeGPAFlag]=(0) AND [MinCumulativeGPA]=(0)) |
| Chk_FaApproveDisbCriteriaSubsequent_MaxDiffDisbAmtFlag_MaxDiffDisbAmt |
([MaxDiffDisbAmtFlag]=(1) AND [MaxDiffDisbAmt]>=(0) OR [MaxDiffDisbAmtFlag]=(0) AND [MaxDiffDisbAmt]=(0)) |
| Chk_FaApproveDisbCriteriaSubsequent_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate |
([MaxDaysFromLoanEndDateFlag]=(1) AND [MaxDaysFromLoanEndDate]>=(0) OR [MaxDaysFromLoanEndDateFlag]=(0) AND [MaxDaysFromLoanEndDate]=(0)) |
| Chk_FaApproveDisbCriteriaSubsequent_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA |
([MaxDaysAfterStudLDAFlag]=(1) AND [MaxDaysAfterStudLDA]>=(0) OR [MaxDaysAfterStudLDAFlag]=(0) AND [MaxDaysAfterStudLDAFlag]=(0)) |
| Chk_FaApproveDisbCriteriaSubsequent_MinPctAttFlag_MinPctAtt |
([MinPctAttFlag]=(1) AND [MinPctAtt]>(0) OR [MinPctAttFlag]=(0) AND [MinPctAtt]=(0)) |
| Chk_FaApproveDisbCriteriaSubsequent_MinNumAvgFlag_MinNumAvg |
([MinNumAvgFlag]=(1) AND [MinNumAvg]>(0) OR [MinNumAvgFlag]=(0) AND [MinNumAvg]=(0)) |
| Chk_FaApproveDisbCriteriaSubsequent_MinHoursAttFlag_MinHoursAtt |
([MinHoursAttFlag]=(1) AND [MinHoursAtt]>(0) OR [MinHoursAttFlag]=(0) AND [MinHoursAtt]=(0)) |
| Chk_[FaApproveDisbCriteriaSubsequent_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched |
|
| Chk_[FaApproveDisbCriteriaSubsequent_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp |
|